package com.lizheng.yunservice.travel.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lizheng.yunservice.travel.doamin.VtpScenic;
import com.lizheng.yunservice.travel.doamin.vo.VtpAppScenicListVo;
import com.lizheng.yunservice.travel.doamin.vo.VtpScenicCategoryVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface VtpAppScenicMapper extends BaseMapper<VtpScenic> {
    
    List<VtpScenic> selectNearbyScenicSpots(
        @Param("longitude") Double longitude,
        @Param("latitude") Double latitude,
        @Param("distance") Double distanceInKm
    );

    VtpScenic selectByScenicId(@Param("scenicId") Integer scenicId);
    
    List<VtpScenic> selectAll();

    String selectProvince(@Param("provinceId") int provinceId);

    @Select("select * from vtp_scenic_category")
    List<VtpScenicCategoryVo> getScenicCategoryList();

    List<VtpAppScenicListVo> getScenicList(@Param("id") Long id);
}
